CREATE TABLE [dbo].[Prepod]
(
[itab_n] [int] NOT NULL IDENTITY(1, 1),
[ik_rank] [int] NULL,
[ik_degree] [int] NULL,
[prepLogin] [varchar] (50) COLLATE Cyrillic_General_CI_AS NULL,
[nCode] [numeric] (18, 0) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Prepod] ADD CONSTRAINT [PK_Prepod_1] PRIMARY KEY CLUSTERED  ([itab_n]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Prepod] ADD CONSTRAINT [IX_Prepod] UNIQUE NONCLUSTERED  ([nCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Prepod] ADD CONSTRAINT [FK_Prepod_Person] FOREIGN KEY ([nCode]) REFERENCES [dbo].[Person] ([nCode])
GO
